package com.li.mapper;

import com.github.pagehelper.Page;
import com.li.pojo.BuildingManage;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @Author: zhiqingLi
 * @Description:
 * @Date: Created in 14:37 2024/3/13
 **/
@Mapper
public interface BuildingManageMapper {

    //查询全部 加上模糊查询
    Page<BuildingManage> showList(BuildingManage buildingManage);

    //添加
    void addSubregion(BuildingManage buildingManage);

    //修改回显
    @Select("select * from building_manage where id = #{id};")
    BuildingManage updGetById(Long id);

    //修改数据
    void updSubregion(BuildingManage buildingManage);

    //伪删除
    void delById(Long id);

    //回显数据小区名字
    @Select("select area_name from building_manage;")
    List<String> showName();
    //回显楼宇
    @Select("select building_num from building_manage;")
    List<Integer> showInter();
}
